package com.jash.labor.mapper.provider;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.SelectProvider;

import java.util.HashMap;

public class StationFavSqlProvider {
    public String laborQueryStationFavList(Page page, Integer company_id){
        String sql = "select s.name,s.salary_start,s.salary_end,requirements,f.address,c.mobile \n" +
                " from company c,first_party f,station_fav sf,station s\n" +
                " where sf.labor_id = "+company_id+" and sf.station_id = s.id \n" +
                " and f.id = s.first_party_id = s.id";
        return sql;
    }

}

